package com.cookor.poi.modules.phy.dao;

import com.cookor.poi.common.persistence.CrudDao;
import com.cookor.poi.common.persistence.annotation.MyBatisDao;
import com.cookor.poi.modules.phy.entity.TPatient;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@MyBatisDao
public interface TPatientDao extends CrudDao<TPatient> {
  @Select({"select *, count(1) count from t_patient WHERE del_flag = 0 group by card, mobile, open_id  HAVING count > 1"})
  List<TPatient> test();
  
  void myDele(@Param("id") String paramString);
}
